1 using System;
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Drawing;
5 using System.Data;
6 using System.Linq;
7 using System.Text;
8 using System.Threading.Tasks;
9 using System.Windows.Forms;
10 using System.Data.SqlClient;
11
12
13 namespace SoftQuanLyNhaHang.Models
14 {
15 class KhachHangMod
16 {
17 protected string IdKhachHang { get; set; }
18 protected string TenKhachHang { get; set; }
19 protected string DienThoai { get; set; }
20 protected string Email { get; set; }
21 protected string DiaChi { get; set; }
22
23 public KhachHangMod(string _IdKhachHang)
24 {
25 IdKhachHang = _IdKhachHang;
26 }
27 public KhachHangMod()
28 { }
29 public KhachHangMod(string _idkhachhang,string _tenkhachhang,string _dienthoai,string _email,string _diachi)
30 {
31 this.IdKhachHang=_idkhachhang;
32 this.TenKhachHang = _tenkhachhang;
33 this.DienThoai = _dienthoai;
34 this.Email = _email;
35 this.DiaChi = _diachi;
36
37 }
38 public int InsertKhachHang()
39 {
40 int i = 0;
41 string[] paras = new string[5] { "@IdKhachHang", "@TenKhachHang", "@DienThoai", "@Email", "@DiaChi" };
42 object[] values = new object[5] { IdKhachHang, TenKhachHang, DienThoai,Email,DiaChi };
43 i = Models.connection.Excute_Sql("spInsertKhachHang", CommandType.StoredProcedure, paras, values);
44 return i;
45 }
46 public int UpdateKhachHang()
47 {
48 int i = 0;
49 string[] paras = new string[5] { "@IdKhachHang", "@TenKhachHang", "@DienThoai", "@Email", "@DiaChi" };
50 object[] values = new object[5] { IdKhachHang, TenKhachHang, DienThoai,Email,DiaChi};
51 i = Models.connection.Excute_Sql("spUpdateKhachHang", CommandType.StoredProcedure, paras, values);
52 return i;
53 }
54 public int DeleteKhachHang()
55 {
56 int i = 0;
57 string[] paras = new string[1] { "@IdKhachHang" };
58 object[] values = new object[1] { IdKhachHang };
59 i = Models.connection.Excute_Sql("spDeleteKhachHang", CommandType.StoredProcedure, paras, values);
60 return i;
61 }
62 public static DataSet FillDataSetKhachHang()
63 {
64 return Models.connection.FillDataSet("spgetKhachHang", CommandType.StoredProcedure);
65 }
66 public DataSet FillDataSet_getKhachHangByIdKhachHang()
67 {
68 DataSet ds = new DataSet();
69 string[] paras = new string[1] { "@IdKhachHang" };
70 object[] values = new object[1] { IdKhachHang };
71 ds = Models.connection.FillDataSet("spgetKhachHangByIdKhachHang", CommandType.StoredProcedure, paras, values);
72 return ds;
73 }
74 }
75 }